RELEASE Notes: This section describes Changes and Enhancements made to ApexSQL Clean Best viewed with 'WORD WRAP' unchecked -------------------------------------------------------------------------------------------------- RELEASE 3.0.94 DATE: March 2005 DESCRIPTION: Major Fix/Feature release -------------------------------------------------------------------------------------------------- Enhancement: New redesigned interface, with support for Office 2003 style themes. Enhancement: All actions were reviewed and disabled in processing mode, to avoid illegal operations while performing actions related to database objects Enhancement: Added option to stop current database/files processing Fix: Fixed error while parsing database SQL drop statements, that raised "Incorrect syntax near GO" in perfectly correct SQL scripts Fix: Fixed "access violation" bug that caused the application to hang when closing the internal editor with a large amount of text selected Fix: Internal editor adjusted to properly handle code written in different languages Fix: Fixed incorrect caption of "Re Connect to Database" menu item Fix: Fixed error generated when loading encrypted database objects Fix: Process File Dependencies screen optimized Fix: Fixed tab order of items throughout application Fix: Fixed bug when loading database objects with space caracter at the end of their names Fix: Fixed bug when loading database objects with names containing "'" -------------------------------------------------------------------------------------------------- RELEASE 2.9.93 DATE: Jan 2004 DESCRIPTION: Minor Fix/Feature release -------------------------------------------------------------------------------------------------- Fix: Now support output to Query Analyzer on SQL Servers with hyphens, slashes and other string breaking characters -------------------------------------------------------------------------------------------------- RELEASE 2.8.90 DATE: 21 Jan 2004 DESCRIPTION: Minor Fix/Feature release -------------------------------------------------------------------------------------------------- Fix: Status bar graphics for Views and Procs were reversed Enhancement: Allow for longer than 3 char file extensions Enhancement: Added search for Functions when doing an Application/File search Enhancement: Product Name change and updated help file -------------------------------------------------------------------------------------------------- RELEASE 2.7.88 DATE: 4 Jun 2003 DESCRIPTION: Minor Fix/Feature release -------------------------------------------------------------------------------------------------- Enhancement: Added a trap for required pre-requisites to alert user when such prerequisites such as ADO and SQLDMO are missing Enhancement: Added "Check for Updates" feature in Help submenu that will validate current version against any new versions of software on the website and alert user if newer version of software exists and direct them to download link Enhancement: Added support for file extensions that are not jus 3 chars long Fix: Fixed General Protection Fault error that occurred on some OS versions when cancel was clicked on Login Dialog Fix: Option for Case Sensitive search was reversed Fix: Fixed Case Else Error (I got one report of it) in CheckTableDependancies Change: Made recursive file check box default to FALSE ---------------------------------------------------------------------------------- RELEASE 2.6.85 Date: 10 Feb 2003 Description: Small Fix Release ---------------------------------------------------------------------------------- Enhancement: Improved interface slightly by replacing check boxes for "Has Children" and "Has Parent" with graphics but preserving ability to sort Fix: [SQL-DMO]This object has been detached from SQLDMO, as the result of a refresh, automatic shutdown, error, or App.Quit. ---------------------------------------------------------------------------------- RELEASE 2.5.83 Date: 24 Jan 2003 Description: Medium Fix / Feature Release ---------------------------------------------------------------------------------- Enhancement: Updated interface - moved form buttons to toolbar for expand, collapse, group, ungroup Enhancement: Made default sort order in grouping Object Type, Name - automatically sort by Name Ascending on grid load Enhancement: Automatically check database for references on application load Enhancement: Improved look of Graph form Enhancement: Now allows Sorting by columns "Is Ref'd" and "Has Refs" (now "Has Parents" and "Has Children") Enhancement: Changed column labels from "Is Ref'd" and "Has Refs" to "Has Parents" and "Has Children" Enhancement: Updated some form icons "Database" >> "Server" Enhancement: Significantly altered interface to move "Parents" and "Children" grids to bottom form from the right side of the form Enhancement: Added QuickLaunch and Shortcut icons to installation scenario Fix: Fixed a General Protection Fault error that occurred on some OS versions when the main form (via File Menu) or login form was closed ---------------------------------------------------------------------------------- RELEASE 2.4.80 Date: 2 Sept 2002 Description: Minor Fix Release ---------------------------------------------------------------------------------- Change: Eliminated Minimize button on results form Change: Changed labels ---------------------------------------------------------------------------------- RELEASE 2.3.76 Date: 8/4/02 Description: Minor Fix Release ---------------------------------------------------------------------------------- Fix: Fixed problem where no login was permitted if sql password was required - still not fixed from previous version ---------------------------------------------------------------------------------- RELEASE 2.2.75 Date: 7/25/02 Description: Minor Fix Release ---------------------------------------------------------------------------------- Fix: Fixed "basFunctions.Refresh_StatusBar" Error Fix: Fixed "frmMain.cboDatabase_Click" Error Line: 26 Error Fix: Fixed problem where no login was permitted if sql password was required Fix: Fixed problem where double clicking on file reference produced an error Fix: Fixed problem where sql objects were not being syntax highlighted with yellow if a new database was selection after another one had already been logged into. Fix: Removed a dependancy on SQLDMO for Version SQL Server 2000 that would cause ActiveX error on login Fix: UDFs weren't being processed properly. ---------------------------------------------------------------------------------- RELEASE 2.1.71 Date: 7/18/02 Description: Minor Enhancement Release ---------------------------------------------------------------------------------- Enhancement: Updated Help file and a few small tweaks made (minor enhancements) ---------------------------------------------------------------------------------- RELEASE 2.0.70 Date: 7/17/02 Description: New Version - most new features undocumented ---------------------------------------------------------------------------------- Help file has not yet been updated. Enhancement: Improved view SQL DDL form Enhancement: Added ability to cancel the loading of Database METADATA Enhancement: Improved toolbars for main and results form Enhancement: Added tooltips Enhancement: Removes system databases from database list Enhancement: show Table DDL on double click Enhancement: Added option to Exclude System Tables - See Options form >> Configuration Enhancement: Updated Data Access routine for better error handling and diagnostics Enhancement: Optimized code for setting editor language (a frequent source of bugs) Enhancement: Added database name to form caption Enhancement: Locked down interface better to force user to login before attempting to perform database operations Enhancement: Added progress bar meter for loading sql objects into memory Fix: Fixed problem in registration form where eval period wasn't working for countries that use MM/DD/YYYY Date format Fix: Fixed problem where Cancel on Database login form was hanging the app Fix: Enabled File Menu when result script loads - before you had to click on code window to enable file menu items (i.e. Copy to Clipboard) Fix: Prevented unauthorized actions if database has not yet been selected Fix: Fixed a database case sensitive issue sp_helpText Fix: Fixed formatting of records and record % in the status bar Fix: Fixed "frmFolderFind.cmdGetFileList_Click" bug in File Search - when Recursive Check box is set to false Change: For security reasons eliminated the feature by which Database password was remembered by the application ---------------------------------------------------------------------------------- RELEASE 1.4.65 Date: 11/28/01 Description: Fix Release ---------------------------------------------------------------------------------- FIX: Fixed problem with case sensitive databases Enhancement: Improved Login screen Enhancement: Improved Results form Enhancement: Enhanced interface graphics Enhancement: Added output options of SQL Query Analyzer and Suppress Output Enhancement: Added ability to view DDL for sprocs, views and additional information for tables by double clicking Enhancement: Updated help file ---------------------------------------------------------------------------------- RELEASE 1.3.63 Date: 08/16/01 Description: Fix Release ---------------------------------------------------------------------------------- FIX: Stored procedures were not being processed when Database was analyzed FIX: Performance for database processing improved significantly Enhancement: Improved help file ---------------------------------------------------------------------------------- RELEASE 1.2.60 Date: 07/15/01 Description: Fix Release ---------------------------------------------------------------------------------- FIX: Fixed problem where Drop statements were generating fatal error FIX: Performance for database processing improved significantly Enhancement: Improved help file ---------------------------------------------------------------------------------- RELEASE 1.1.57 Date: 07/15/01 Description: Fix Release ---------------------------------------------------------------------------------- FIX: Fixed form resize error on Drop SQL form ---------------------------------------------------------------------------------- RELEASE 1.0.55 Date: 07/11/01 Description: Initial Release ---------------------------------------------------------------------------------- This is the first release of SQLClean